select distinct substring(name,1,1) from stamps ,printsize_master where year(stamps.issue_date)=2001 and month(issue_date)=10 and dayofmonth(stamps.issue_date)=11 and printsize_master.printsize_code=stamps.printsize_code and printsize_master.printsize='2.90 x 3.9' order by substring(name,1,1)
|
|
Issue Date >> year >> 2001 >> month >> October >> day >> 11 >> Print Size >> 2.90 x 3.9 >> Alpha >> J >>
|
|
Stamps sorted by Issue Date 2001 October, 11, Print Size 2.90 x 3.9, Alpha J
|
|
|
|
|
|
|
Our Other Sites MediaWorld.Info RajPurohit.com FreedomIndia.com